﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Bai01.Properties;
namespace Bai01
{
    class NhanVienDAO
    {
        public static void them(NhanVien NV)
        {
            string sql = "insert into NHAN_VIEN(manv,tennv,ngaysinh,maloainv,gioitinh,diachi) values";
            sql += "(N'" + NV.MaNV + "','";
            sql += NV.TenNV + "','";
            sql += NV.Ngaysinh + "',";
            sql += NV.MaLoai + ",";
            sql += NV.GioiTinh + ",'";
            sql += NV.DiaChi + "')"; // stored proc 
            // (N'1','Nguyen','10/11/231',1,1,'sd')
            DataProvider.executeNonQuery(sql);


        }
    }
}
